--create user ops identified by ops;
--grant create session,create table,create procedure, create synonym, create sequence to ops;
--alter user ops quota 100m on system;
--GRANT UNLIMITED TABLESPACE TO ops;


--alter system set local_listener = '(ADDRESS=(PROTOCOL=TCP)(HOST=SUMAN-PC)(PORT=1521))' scope=memory;
--alter system register;

--drop table OPS_USER_ROLES;
--drop table OPS_ROLE_MENUS;
--drop table OPS_MENUS;
--drop table OPS_ROLES;


CREATE SEQUENCE OPS_USERS_SEQ START WITH 1000 INCREMENT BY 1 MAXVALUE 9999999999 NOCACHE NOCYCLE;
CREATE SEQUENCE OPS_USERS_ROLE_SEQ START WITH 1000 INCREMENT BY 1 MAXVALUE 9999999999 NOCACHE NOCYCLE;

INSERT INTO OPS_ROLES(Role_id,Role_Name,Start_Date_Active,End_Date_Active,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session)VALUES(1,'Employer',SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_ROLES(Role_id,Role_Name,Start_Date_Active,End_Date_Active,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session)VALUES(2,'Accountant',SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_ROLES(Role_id,Role_Name,Start_Date_Active,End_Date_Active,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session)VALUES(3,'Employee',SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_ROLES(Role_id,Role_Name,Start_Date_Active,End_Date_Active,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session)VALUES(4,'Internal',SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

INSERT INTO OPS_USERS(USER_ID,USER_NAME,USER_STATUS,CREATED_BY,CREATED_DATE,CREATED_SESSION,UPDATED_BY,UPDATED_DATE,UPDATED_SESSION,DELETED_BY,DELETED_DATE,DELETED_SESSION,USER_PASSWORD)VALUES(OPS_USERS_SEQ.NEXTVAL,'Admin','A',0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'test');
INSERT INTO OPS_USER_ROLES(User_Role_id,User_id,Role_id,Start_Date_Active,End_Date_Active,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session)VALUES(OPS_USERS_ROLE_SEQ.NEXTVAL,OPS_USERS_SEQ.CURRVAL,1,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

INSERT INTO OPS_MENUS(Menu_id,Menu_Name,Parent_Menu_Id,MENU_CLASS,MENU_DIVISION,MENU_URL,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session,Start_Date_Active,End_Date_Active)VALUES(1,'Employer',NULL,'user','','/include/content/welcome.jspx',0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL,SYSDATE,NULL);
INSERT INTO OPS_MENUS(Menu_id,Menu_Name,Parent_Menu_Id,MENU_CLASS,MENU_DIVISION,MENU_URL,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session,Start_Date_Active,End_Date_Active)VALUES(2,'Setup',1,'','Y','/include/content/welcome.jspx',0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL,SYSDATE,NULL);
INSERT INTO OPS_MENUS(Menu_id,Menu_Name,Parent_Menu_Id,MENU_CLASS,MENU_DIVISION,MENU_URL,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session,Start_Date_Active,End_Date_Active)VALUES(3,'Tax Authorities',1,'','N','/include/content/welcome.jspx',0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL,SYSDATE,NULL);
INSERT INTO OPS_MENUS(Menu_id,Menu_Name,Parent_Menu_Id,MENU_CLASS,MENU_DIVISION,MENU_URL,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session,Start_Date_Active,End_Date_Active)VALUES(4,'Pay Types',1,'','N','/include/content/welcome.jspx',0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL,SYSDATE,NULL);
INSERT INTO OPS_MENUS(Menu_id,Menu_Name,Parent_Menu_Id,MENU_CLASS,MENU_DIVISION,MENU_URL,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session,Start_Date_Active,End_Date_Active)VALUES(5,'Deductions',1,'','Y','/include/content/welcome.jspx',0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL,SYSDATE,NULL);
INSERT INTO OPS_MENUS(Menu_id,Menu_Name,Parent_Menu_Id,MENU_CLASS,MENU_DIVISION,MENU_URL,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session,Start_Date_Active,End_Date_Active)VALUES(6,'Departments',1,'','N','/include/content/welcome.jspx',0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL,SYSDATE,NULL);
INSERT INTO OPS_MENUS(Menu_id,Menu_Name,Parent_Menu_Id,MENU_CLASS,MENU_DIVISION,MENU_URL,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session,Start_Date_Active,End_Date_Active)VALUES(7,'Locations',1,'','N','/include/content/welcome.jspx',0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL,SYSDATE,NULL);
INSERT INTO OPS_MENUS(Menu_id,Menu_Name,Parent_Menu_Id,MENU_CLASS,MENU_DIVISION,MENU_URL,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session,Start_Date_Active,End_Date_Active)VALUES(8,'Job Classifications',1,'','N','/include/content/welcome.jspx',0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL,SYSDATE,NULL);
INSERT INTO OPS_MENUS(Menu_id,Menu_Name,Parent_Menu_Id,MENU_CLASS,MENU_DIVISION,MENU_URL,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session,Start_Date_Active,End_Date_Active)VALUES(9,'Employee Groups',1,'','Y','/include/content/welcome.jspx',0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL,SYSDATE,NULL);
INSERT INTO OPS_MENUS(Menu_id,Menu_Name,Parent_Menu_Id,MENU_CLASS,MENU_DIVISION,MENU_URL,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session,Start_Date_Active,End_Date_Active)VALUES(10,'Contacts',1,'','N','/include/content/welcome.jspx',0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL,SYSDATE,NULL);
INSERT INTO OPS_MENUS(Menu_id,Menu_Name,Parent_Menu_Id,MENU_CLASS,MENU_DIVISION,MENU_URL,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session,Start_Date_Active,End_Date_Active)VALUES(11,'3rd Party Payees',1,'','Y','/include/content/welcome.jspx',0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL,SYSDATE,NULL);
INSERT INTO OPS_MENUS(Menu_id,Menu_Name,Parent_Menu_Id,MENU_CLASS,MENU_DIVISION,MENU_URL,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session,Start_Date_Active,End_Date_Active)VALUES(12,'Employee',NULL,'user','','/include/content/welcome.jspx',0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL,SYSDATE,NULL);
INSERT INTO OPS_MENUS(Menu_id,Menu_Name,Parent_Menu_Id,MENU_CLASS,MENU_DIVISION,MENU_URL,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session,Start_Date_Active,End_Date_Active)VALUES(13,'Information',12,'','N','/include/content/welcome.jspx',0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL,SYSDATE,NULL);
INSERT INTO OPS_MENUS(Menu_id,Menu_Name,Parent_Menu_Id,MENU_CLASS,MENU_DIVISION,MENU_URL,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session,Start_Date_Active,End_Date_Active)VALUES(14,'Compensation',12,'','Y','/include/content/welcome.jspx',0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL,SYSDATE,NULL);
INSERT INTO OPS_MENUS(Menu_id,Menu_Name,Parent_Menu_Id,MENU_CLASS,MENU_DIVISION,MENU_URL,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session,Start_Date_Active,End_Date_Active)VALUES(15,'Pay Types',12,'','N','/include/content/welcome.jspx',0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL,SYSDATE,NULL);
INSERT INTO OPS_MENUS(Menu_id,Menu_Name,Parent_Menu_Id,MENU_CLASS,MENU_DIVISION,MENU_URL,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session,Start_Date_Active,End_Date_Active)VALUES(16,'Deductions',12,'','N','/include/content/welcome.jspx',0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL,SYSDATE,NULL);
INSERT INTO OPS_MENUS(Menu_id,Menu_Name,Parent_Menu_Id,MENU_CLASS,MENU_DIVISION,MENU_URL,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session,Start_Date_Active,End_Date_Active)VALUES(17,'Garnishments',12,'','Y','/include/content/welcome.jspx',0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL,SYSDATE,NULL);
INSERT INTO OPS_MENUS(Menu_id,Menu_Name,Parent_Menu_Id,MENU_CLASS,MENU_DIVISION,MENU_URL,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session,Start_Date_Active,End_Date_Active)VALUES(18,'Payroll',NULL,'user','','/include/content/welcome.jspx',0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL,SYSDATE,NULL);
INSERT INTO OPS_MENUS(Menu_id,Menu_Name,Parent_Menu_Id,MENU_CLASS,MENU_DIVISION,MENU_URL,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session,Start_Date_Active,End_Date_Active)VALUES(19,'Entry',18,'','N','/include/content/welcome.jspx',0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL,SYSDATE,NULL);
INSERT INTO OPS_MENUS(Menu_id,Menu_Name,Parent_Menu_Id,MENU_CLASS,MENU_DIVISION,MENU_URL,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session,Start_Date_Active,End_Date_Active)VALUES(20,'Review',18,'','N','/include/content/welcome.jspx',0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL,SYSDATE,NULL);
INSERT INTO OPS_MENUS(Menu_id,Menu_Name,Parent_Menu_Id,MENU_CLASS,MENU_DIVISION,MENU_URL,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session,Start_Date_Active,End_Date_Active)VALUES(21,'Admin',NULL,'admin','','/include/content/welcome.jspx',0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL,SYSDATE,NULL);
INSERT INTO OPS_MENUS(Menu_id,Menu_Name,Parent_Menu_Id,MENU_CLASS,MENU_DIVISION,MENU_URL,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session,Start_Date_Active,End_Date_Active)VALUES(22,'Users',21,'','N','/include/content/users.jspx',0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL,SYSDATE,NULL);
INSERT INTO OPS_MENUS(Menu_id,Menu_Name,Parent_Menu_Id,MENU_CLASS,MENU_DIVISION,MENU_URL,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session,Start_Date_Active,End_Date_Active)VALUES(23,'User Sessions',21,'','N','/include/content/usersessions.jspx',0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL,SYSDATE,NULL);
INSERT INTO OPS_MENUS(Menu_id,Menu_Name,Parent_Menu_Id,MENU_CLASS,MENU_DIVISION,MENU_URL,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session,Start_Date_Active,End_Date_Active)VALUES(24,'User Actions',21,'','Y','/include/content/useraction.jspx',0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL,SYSDATE,NULL);
INSERT INTO OPS_MENUS(Menu_id,Menu_Name,Parent_Menu_Id,MENU_CLASS,MENU_DIVISION,MENU_URL,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session,Start_Date_Active,End_Date_Active)VALUES(25,'WS Log',21,'','N','/include/content/welcome.jspx',0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL,SYSDATE,NULL);
INSERT INTO OPS_MENUS(Menu_id,Menu_Name,Parent_Menu_Id,MENU_CLASS,MENU_DIVISION,MENU_URL,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session,Start_Date_Active,End_Date_Active)VALUES(26,'Parameters',21,'','N','/include/content/parameters.jspx',0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL,SYSDATE,NULL);
INSERT INTO OPS_MENUS(Menu_id,Menu_Name,Parent_Menu_Id,MENU_CLASS,MENU_DIVISION,MENU_URL,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session,Start_Date_Active,End_Date_Active)VALUES(27,'Messages',21,'','N','/include/content/messages.jspx',0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL,SYSDATE,NULL);
INSERT INTO OPS_MENUS(Menu_id,Menu_Name,Parent_Menu_Id,MENU_CLASS,MENU_DIVISION,MENU_URL,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session,Start_Date_Active,End_Date_Active)VALUES(28,'Lookups',21,'','Y','/include/content/lookups.jspx',0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL,SYSDATE,NULL);
INSERT INTO OPS_MENUS(Menu_id,Menu_Name,Parent_Menu_Id,MENU_CLASS,MENU_DIVISION,MENU_URL,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session,Start_Date_Active,End_Date_Active)VALUES(29,'Rules',21,'','N','/include/content/rules.jspx',0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL,SYSDATE,NULL);
INSERT INTO OPS_MENUS(Menu_id,Menu_Name,Parent_Menu_Id,MENU_CLASS,MENU_DIVISION,MENU_URL,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session,Start_Date_Active,End_Date_Active)VALUES(30,'Rule Binds',21,'','N','/include/content/rulebind.jspx',0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL,SYSDATE,NULL);
INSERT INTO OPS_MENUS(Menu_id,Menu_Name,Parent_Menu_Id,MENU_CLASS,MENU_DIVISION,MENU_URL,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session,Start_Date_Active,End_Date_Active)VALUES(31,'Rule Values',21,'','N','/include/content/welcome.jspx',0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL,SYSDATE,NULL);
INSERT INTO OPS_MENUS(Menu_id,Menu_Name,Parent_Menu_Id,MENU_CLASS,MENU_DIVISION,MENU_URL,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session,Start_Date_Active,End_Date_Active)VALUES(32,'Rule Rates',21,'','N','/include/content/rulerate.jspx',0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL,SYSDATE,NULL);
INSERT INTO OPS_MENUS(Menu_id,Menu_Name,Parent_Menu_Id,MENU_CLASS,MENU_DIVISION,MENU_URL,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session,Start_Date_Active,End_Date_Active)VALUES(33,'Tax Authorities',21,'','N','/include/content/taxauthorities.jspx',0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL,SYSDATE,NULL);

INSERT INTO OPS_ROLE_MENUS(Role_Menu_id,Menu_id,Role_id,Start_Date_Active,End_Date_Active,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session)VALUES(1,1,1,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_ROLE_MENUS(Role_Menu_id,Menu_id,Role_id,Start_Date_Active,End_Date_Active,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session)VALUES(2,2,1,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_ROLE_MENUS(Role_Menu_id,Menu_id,Role_id,Start_Date_Active,End_Date_Active,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session)VALUES(3,3,1,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_ROLE_MENUS(Role_Menu_id,Menu_id,Role_id,Start_Date_Active,End_Date_Active,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session)VALUES(4,4,1,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_ROLE_MENUS(Role_Menu_id,Menu_id,Role_id,Start_Date_Active,End_Date_Active,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session)VALUES(5,5,1,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_ROLE_MENUS(Role_Menu_id,Menu_id,Role_id,Start_Date_Active,End_Date_Active,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session)VALUES(6,6,1,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_ROLE_MENUS(Role_Menu_id,Menu_id,Role_id,Start_Date_Active,End_Date_Active,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session)VALUES(7,7,1,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_ROLE_MENUS(Role_Menu_id,Menu_id,Role_id,Start_Date_Active,End_Date_Active,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session)VALUES(8,8,1,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_ROLE_MENUS(Role_Menu_id,Menu_id,Role_id,Start_Date_Active,End_Date_Active,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session)VALUES(9,9,1,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_ROLE_MENUS(Role_Menu_id,Menu_id,Role_id,Start_Date_Active,End_Date_Active,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session)VALUES(10,10,1,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_ROLE_MENUS(Role_Menu_id,Menu_id,Role_id,Start_Date_Active,End_Date_Active,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session)VALUES(11,11,1,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_ROLE_MENUS(Role_Menu_id,Menu_id,Role_id,Start_Date_Active,End_Date_Active,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session)VALUES(12,12,1,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_ROLE_MENUS(Role_Menu_id,Menu_id,Role_id,Start_Date_Active,End_Date_Active,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session)VALUES(13,13,1,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_ROLE_MENUS(Role_Menu_id,Menu_id,Role_id,Start_Date_Active,End_Date_Active,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session)VALUES(14,14,1,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_ROLE_MENUS(Role_Menu_id,Menu_id,Role_id,Start_Date_Active,End_Date_Active,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session)VALUES(15,15,1,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_ROLE_MENUS(Role_Menu_id,Menu_id,Role_id,Start_Date_Active,End_Date_Active,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session)VALUES(16,16,1,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_ROLE_MENUS(Role_Menu_id,Menu_id,Role_id,Start_Date_Active,End_Date_Active,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session)VALUES(17,17,1,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_ROLE_MENUS(Role_Menu_id,Menu_id,Role_id,Start_Date_Active,End_Date_Active,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session)VALUES(18,18,1,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_ROLE_MENUS(Role_Menu_id,Menu_id,Role_id,Start_Date_Active,End_Date_Active,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session)VALUES(19,19,1,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_ROLE_MENUS(Role_Menu_id,Menu_id,Role_id,Start_Date_Active,End_Date_Active,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session)VALUES(20,20,1,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_ROLE_MENUS(Role_Menu_id,Menu_id,Role_id,Start_Date_Active,End_Date_Active,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session)VALUES(21,21,1,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_ROLE_MENUS(Role_Menu_id,Menu_id,Role_id,Start_Date_Active,End_Date_Active,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session)VALUES(22,22,1,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_ROLE_MENUS(Role_Menu_id,Menu_id,Role_id,Start_Date_Active,End_Date_Active,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session)VALUES(23,23,1,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_ROLE_MENUS(Role_Menu_id,Menu_id,Role_id,Start_Date_Active,End_Date_Active,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session)VALUES(24,24,1,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_ROLE_MENUS(Role_Menu_id,Menu_id,Role_id,Start_Date_Active,End_Date_Active,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session)VALUES(25,25,1,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_ROLE_MENUS(Role_Menu_id,Menu_id,Role_id,Start_Date_Active,End_Date_Active,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session)VALUES(26,26,1,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_ROLE_MENUS(Role_Menu_id,Menu_id,Role_id,Start_Date_Active,End_Date_Active,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session)VALUES(27,27,1,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_ROLE_MENUS(Role_Menu_id,Menu_id,Role_id,Start_Date_Active,End_Date_Active,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session)VALUES(28,28,1,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_ROLE_MENUS(Role_Menu_id,Menu_id,Role_id,Start_Date_Active,End_Date_Active,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session)VALUES(29,29,1,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_ROLE_MENUS(Role_Menu_id,Menu_id,Role_id,Start_Date_Active,End_Date_Active,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session)VALUES(30,30,1,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_ROLE_MENUS(Role_Menu_id,Menu_id,Role_id,Start_Date_Active,End_Date_Active,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session)VALUES(31,31,1,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_ROLE_MENUS(Role_Menu_id,Menu_id,Role_id,Start_Date_Active,End_Date_Active,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session)VALUES(32,32,1,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_ROLE_MENUS(Role_Menu_id,Menu_id,Role_id,Start_Date_Active,End_Date_Active,Create_By,Create_Date,Create_Session,Update_By,Update_Date,Update_Session,Delete_By,Delete_Date,Delete_Session)VALUES(33,33,1,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

ALTER TABLE OPS_PARAMETERS ADD PARAMETER_KEY VARCHAR2(100);
CREATE SEQUENCE OPS_LOOKUPS_SEQ START WITH 1000 INCREMENT BY 1 MAXVALUE 9999999999 NOCACHE NOCYCLE;

INSERT INTO OPS_LOOKUPS(LOOKUP_ID,LOOKUP_TYPE,LOOKUP_VALUE_KEY,LOOKUP_VALUE_NAME,LOOKUP_VALUE_DESCRIPTION,ASSOCIATED_RULE,START_DATE_ACTIVE,END_DATE_ACTIVE,CREATED_BY,CREATED_DATE,CREATED_SESSION,UPDATED_BY,UPDATED_DATE,UPDATED_SESSION,DELETED_BY,DELETED_DATE,DELETED_SESSION)VALUES(OPS_LOOKUPS_SEQ.NEXTVAL,'DATE-FORMAT','DFORMAT','DD/MM/YYYY',NULL,NULL,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_LOOKUPS(LOOKUP_ID,LOOKUP_TYPE,LOOKUP_VALUE_KEY,LOOKUP_VALUE_NAME,LOOKUP_VALUE_DESCRIPTION,ASSOCIATED_RULE,START_DATE_ACTIVE,END_DATE_ACTIVE,CREATED_BY,CREATED_DATE,CREATED_SESSION,UPDATED_BY,UPDATED_DATE,UPDATED_SESSION,DELETED_BY,DELETED_DATE,DELETED_SESSION)VALUES(OPS_LOOKUPS_SEQ.NEXTVAL,'DATE-TIME-FORMAT','DTFORMAT','DD/MM/YYYY HH24:MI:SS',NULL,NULL,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_LOOKUPS(LOOKUP_ID,LOOKUP_TYPE,LOOKUP_VALUE_KEY,LOOKUP_VALUE_NAME,LOOKUP_VALUE_DESCRIPTION,ASSOCIATED_RULE,START_DATE_ACTIVE,END_DATE_ACTIVE,CREATED_BY,CREATED_DATE,CREATED_SESSION,UPDATED_BY,UPDATED_DATE,UPDATED_SESSION,DELETED_BY,DELETED_DATE,DELETED_SESSION)VALUES(OPS_LOOKUPS_SEQ.NEXTVAL,'OPS-MAX-DATE','MAXDATE','01/01/9999',NULL,NULL,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_LOOKUPS(LOOKUP_ID,LOOKUP_TYPE,LOOKUP_VALUE_KEY,LOOKUP_VALUE_NAME,LOOKUP_VALUE_DESCRIPTION,ASSOCIATED_RULE,START_DATE_ACTIVE,END_DATE_ACTIVE,CREATED_BY,CREATED_DATE,CREATED_SESSION,UPDATED_BY,UPDATED_DATE,UPDATED_SESSION,DELETED_BY,DELETED_DATE,DELETED_SESSION)VALUES(OPS_LOOKUPS_SEQ.NEXTVAL,'PARAMETER-TYPE','S','String',NULL,NULL,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_LOOKUPS(LOOKUP_ID,LOOKUP_TYPE,LOOKUP_VALUE_KEY,LOOKUP_VALUE_NAME,LOOKUP_VALUE_DESCRIPTION,ASSOCIATED_RULE,START_DATE_ACTIVE,END_DATE_ACTIVE,CREATED_BY,CREATED_DATE,CREATED_SESSION,UPDATED_BY,UPDATED_DATE,UPDATED_SESSION,DELETED_BY,DELETED_DATE,DELETED_SESSION)VALUES(OPS_LOOKUPS_SEQ.NEXTVAL,'PARAMETER-TYPE','N','Number',NULL,NULL,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_LOOKUPS(LOOKUP_ID,LOOKUP_TYPE,LOOKUP_VALUE_KEY,LOOKUP_VALUE_NAME,LOOKUP_VALUE_DESCRIPTION,ASSOCIATED_RULE,START_DATE_ACTIVE,END_DATE_ACTIVE,CREATED_BY,CREATED_DATE,CREATED_SESSION,UPDATED_BY,UPDATED_DATE,UPDATED_SESSION,DELETED_BY,DELETED_DATE,DELETED_SESSION)VALUES(OPS_LOOKUPS_SEQ.NEXTVAL,'PARAMETER-TYPE','B','Boolean',NULL,NULL,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_LOOKUPS(LOOKUP_ID,LOOKUP_TYPE,LOOKUP_VALUE_KEY,LOOKUP_VALUE_NAME,LOOKUP_VALUE_DESCRIPTION,ASSOCIATED_RULE,START_DATE_ACTIVE,END_DATE_ACTIVE,CREATED_BY,CREATED_DATE,CREATED_SESSION,UPDATED_BY,UPDATED_DATE,UPDATED_SESSION,DELETED_BY,DELETED_DATE,DELETED_SESSION)VALUES(OPS_LOOKUPS_SEQ.NEXTVAL,'LANGUAGE','EN','English',NULL,NULL,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_LOOKUPS(LOOKUP_ID,LOOKUP_TYPE,LOOKUP_VALUE_KEY,LOOKUP_VALUE_NAME,LOOKUP_VALUE_DESCRIPTION,ASSOCIATED_RULE,START_DATE_ACTIVE,END_DATE_ACTIVE,CREATED_BY,CREATED_DATE,CREATED_SESSION,UPDATED_BY,UPDATED_DATE,UPDATED_SESSION,DELETED_BY,DELETED_DATE,DELETED_SESSION)VALUES(OPS_LOOKUPS_SEQ.NEXTVAL,'LANGUAGE','FR','French',NULL,NULL,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_LOOKUPS(LOOKUP_ID,LOOKUP_TYPE,LOOKUP_VALUE_KEY,LOOKUP_VALUE_NAME,LOOKUP_VALUE_DESCRIPTION,ASSOCIATED_RULE,START_DATE_ACTIVE,END_DATE_ACTIVE,CREATED_BY,CREATED_DATE,CREATED_SESSION,UPDATED_BY,UPDATED_DATE,UPDATED_SESSION,DELETED_BY,DELETED_DATE,DELETED_SESSION)VALUES(OPS_LOOKUPS_SEQ.NEXTVAL,'LANGUAGE','HI','Hindi',NULL,NULL,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_LOOKUPS(LOOKUP_ID,LOOKUP_TYPE,LOOKUP_VALUE_KEY,LOOKUP_VALUE_NAME,LOOKUP_VALUE_DESCRIPTION,ASSOCIATED_RULE,START_DATE_ACTIVE,END_DATE_ACTIVE,CREATED_BY,CREATED_DATE,CREATED_SESSION,UPDATED_BY,UPDATED_DATE,UPDATED_SESSION,DELETED_BY,DELETED_DATE,DELETED_SESSION)VALUES(OPS_LOOKUPS_SEQ.NEXTVAL,'RULE-GROUP','E','Employee',NULL,NULL,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_LOOKUPS(LOOKUP_ID,LOOKUP_TYPE,LOOKUP_VALUE_KEY,LOOKUP_VALUE_NAME,LOOKUP_VALUE_DESCRIPTION,ASSOCIATED_RULE,START_DATE_ACTIVE,END_DATE_ACTIVE,CREATED_BY,CREATED_DATE,CREATED_SESSION,UPDATED_BY,UPDATED_DATE,UPDATED_SESSION,DELETED_BY,DELETED_DATE,DELETED_SESSION)VALUES(OPS_LOOKUPS_SEQ.NEXTVAL,'RULE-GROUP','U','US Federal',NULL,NULL,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_LOOKUPS(LOOKUP_ID,LOOKUP_TYPE,LOOKUP_VALUE_KEY,LOOKUP_VALUE_NAME,LOOKUP_VALUE_DESCRIPTION,ASSOCIATED_RULE,START_DATE_ACTIVE,END_DATE_ACTIVE,CREATED_BY,CREATED_DATE,CREATED_SESSION,UPDATED_BY,UPDATED_DATE,UPDATED_SESSION,DELETED_BY,DELETED_DATE,DELETED_SESSION)VALUES(OPS_LOOKUPS_SEQ.NEXTVAL,'RULE-GROUP','C','US CA',NULL,NULL,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_LOOKUPS(LOOKUP_ID,LOOKUP_TYPE,LOOKUP_VALUE_KEY,LOOKUP_VALUE_NAME,LOOKUP_VALUE_DESCRIPTION,ASSOCIATED_RULE,START_DATE_ACTIVE,END_DATE_ACTIVE,CREATED_BY,CREATED_DATE,CREATED_SESSION,UPDATED_BY,UPDATED_DATE,UPDATED_SESSION,DELETED_BY,DELETED_DATE,DELETED_SESSION)VALUES(OPS_LOOKUPS_SEQ.NEXTVAL,'RULE-TYPE','F','Fixed',NULL,NULL,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_LOOKUPS(LOOKUP_ID,LOOKUP_TYPE,LOOKUP_VALUE_KEY,LOOKUP_VALUE_NAME,LOOKUP_VALUE_DESCRIPTION,ASSOCIATED_RULE,START_DATE_ACTIVE,END_DATE_ACTIVE,CREATED_BY,CREATED_DATE,CREATED_SESSION,UPDATED_BY,UPDATED_DATE,UPDATED_SESSION,DELETED_BY,DELETED_DATE,DELETED_SESSION)VALUES(OPS_LOOKUPS_SEQ.NEXTVAL,'RULE-TYPE','D','Derived',NULL,NULL,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_LOOKUPS(LOOKUP_ID,LOOKUP_TYPE,LOOKUP_VALUE_KEY,LOOKUP_VALUE_NAME,LOOKUP_VALUE_DESCRIPTION,ASSOCIATED_RULE,START_DATE_ACTIVE,END_DATE_ACTIVE,CREATED_BY,CREATED_DATE,CREATED_SESSION,UPDATED_BY,UPDATED_DATE,UPDATED_SESSION,DELETED_BY,DELETED_DATE,DELETED_SESSION)VALUES(OPS_LOOKUPS_SEQ.NEXTVAL,'RULE-TYPE','L','Lookup',NULL,NULL,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_LOOKUPS(LOOKUP_ID,LOOKUP_TYPE,LOOKUP_VALUE_KEY,LOOKUP_VALUE_NAME,LOOKUP_VALUE_DESCRIPTION,ASSOCIATED_RULE,START_DATE_ACTIVE,END_DATE_ACTIVE,CREATED_BY,CREATED_DATE,CREATED_SESSION,UPDATED_BY,UPDATED_DATE,UPDATED_SESSION,DELETED_BY,DELETED_DATE,DELETED_SESSION)VALUES(OPS_LOOKUPS_SEQ.NEXTVAL,'DATA-TYPE','N','Number',NULL,NULL,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_LOOKUPS(LOOKUP_ID,LOOKUP_TYPE,LOOKUP_VALUE_KEY,LOOKUP_VALUE_NAME,LOOKUP_VALUE_DESCRIPTION,ASSOCIATED_RULE,START_DATE_ACTIVE,END_DATE_ACTIVE,CREATED_BY,CREATED_DATE,CREATED_SESSION,UPDATED_BY,UPDATED_DATE,UPDATED_SESSION,DELETED_BY,DELETED_DATE,DELETED_SESSION)VALUES(OPS_LOOKUPS_SEQ.NEXTVAL,'DATA-TYPE','D','Date',NULL,NULL,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_LOOKUPS(LOOKUP_ID,LOOKUP_TYPE,LOOKUP_VALUE_KEY,LOOKUP_VALUE_NAME,LOOKUP_VALUE_DESCRIPTION,ASSOCIATED_RULE,START_DATE_ACTIVE,END_DATE_ACTIVE,CREATED_BY,CREATED_DATE,CREATED_SESSION,UPDATED_BY,UPDATED_DATE,UPDATED_SESSION,DELETED_BY,DELETED_DATE,DELETED_SESSION)VALUES(OPS_LOOKUPS_SEQ.NEXTVAL,'DATA-TYPE','C','Character',NULL,NULL,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_LOOKUPS(LOOKUP_ID,LOOKUP_TYPE,LOOKUP_VALUE_KEY,LOOKUP_VALUE_NAME,LOOKUP_VALUE_DESCRIPTION,ASSOCIATED_RULE,START_DATE_ACTIVE,END_DATE_ACTIVE,CREATED_BY,CREATED_DATE,CREATED_SESSION,UPDATED_BY,UPDATED_DATE,UPDATED_SESSION,DELETED_BY,DELETED_DATE,DELETED_SESSION)VALUES(OPS_LOOKUPS_SEQ.NEXTVAL,'CALC-TYPE','FR','Formula',NULL,NULL,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_LOOKUPS(LOOKUP_ID,LOOKUP_TYPE,LOOKUP_VALUE_KEY,LOOKUP_VALUE_NAME,LOOKUP_VALUE_DESCRIPTION,ASSOCIATED_RULE,START_DATE_ACTIVE,END_DATE_ACTIVE,CREATED_BY,CREATED_DATE,CREATED_SESSION,UPDATED_BY,UPDATED_DATE,UPDATED_SESSION,DELETED_BY,DELETED_DATE,DELETED_SESSION)VALUES(OPS_LOOKUPS_SEQ.NEXTVAL,'CALC-TYPE','FN','Function',NULL,NULL,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_LOOKUPS(LOOKUP_ID,LOOKUP_TYPE,LOOKUP_VALUE_KEY,LOOKUP_VALUE_NAME,LOOKUP_VALUE_DESCRIPTION,ASSOCIATED_RULE,START_DATE_ACTIVE,END_DATE_ACTIVE,CREATED_BY,CREATED_DATE,CREATED_SESSION,UPDATED_BY,UPDATED_DATE,UPDATED_SESSION,DELETED_BY,DELETED_DATE,DELETED_SESSION)VALUES(OPS_LOOKUPS_SEQ.NEXTVAL,'LEVEL','EMP','Employee',NULL,NULL,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_LOOKUPS(LOOKUP_ID,LOOKUP_TYPE,LOOKUP_VALUE_KEY,LOOKUP_VALUE_NAME,LOOKUP_VALUE_DESCRIPTION,ASSOCIATED_RULE,START_DATE_ACTIVE,END_DATE_ACTIVE,CREATED_BY,CREATED_DATE,CREATED_SESSION,UPDATED_BY,UPDATED_DATE,UPDATED_SESSION,DELETED_BY,DELETED_DATE,DELETED_SESSION)VALUES(OPS_LOOKUPS_SEQ.NEXTVAL,'LEVEL','CLI','Client',NULL,NULL,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_LOOKUPS(LOOKUP_ID,LOOKUP_TYPE,LOOKUP_VALUE_KEY,LOOKUP_VALUE_NAME,LOOKUP_VALUE_DESCRIPTION,ASSOCIATED_RULE,START_DATE_ACTIVE,END_DATE_ACTIVE,CREATED_BY,CREATED_DATE,CREATED_SESSION,UPDATED_BY,UPDATED_DATE,UPDATED_SESSION,DELETED_BY,DELETED_DATE,DELETED_SESSION)VALUES(OPS_LOOKUPS_SEQ.NEXTVAL,'BOOLEAN-TYPE','N','No',NULL,NULL,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_LOOKUPS(LOOKUP_ID,LOOKUP_TYPE,LOOKUP_VALUE_KEY,LOOKUP_VALUE_NAME,LOOKUP_VALUE_DESCRIPTION,ASSOCIATED_RULE,START_DATE_ACTIVE,END_DATE_ACTIVE,CREATED_BY,CREATED_DATE,CREATED_SESSION,UPDATED_BY,UPDATED_DATE,UPDATED_SESSION,DELETED_BY,DELETED_DATE,DELETED_SESSION)VALUES(OPS_LOOKUPS_SEQ.NEXTVAL,'BOOLEAN-TYPE','Y','Yes',NULL,NULL,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_LOOKUPS(LOOKUP_ID,LOOKUP_TYPE,LOOKUP_VALUE_KEY,LOOKUP_VALUE_NAME,LOOKUP_VALUE_DESCRIPTION,ASSOCIATED_RULE,START_DATE_ACTIVE,END_DATE_ACTIVE,CREATED_BY,CREATED_DATE,CREATED_SESSION,UPDATED_BY,UPDATED_DATE,UPDATED_SESSION,DELETED_BY,DELETED_DATE,DELETED_SESSION)VALUES(OPS_LOOKUPS_SEQ.NEXTVAL,'FORMULA-SYSTEM','SUM','SUM',NULL,NULL,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_LOOKUPS(LOOKUP_ID,LOOKUP_TYPE,LOOKUP_VALUE_KEY,LOOKUP_VALUE_NAME,LOOKUP_VALUE_DESCRIPTION,ASSOCIATED_RULE,START_DATE_ACTIVE,END_DATE_ACTIVE,CREATED_BY,CREATED_DATE,CREATED_SESSION,UPDATED_BY,UPDATED_DATE,UPDATED_SESSION,DELETED_BY,DELETED_DATE,DELETED_SESSION)VALUES(OPS_LOOKUPS_SEQ.NEXTVAL,'FORMULA-SYSTEM','AVG','AVG',NULL,NULL,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_LOOKUPS(LOOKUP_ID,LOOKUP_TYPE,LOOKUP_VALUE_KEY,LOOKUP_VALUE_NAME,LOOKUP_VALUE_DESCRIPTION,ASSOCIATED_RULE,START_DATE_ACTIVE,END_DATE_ACTIVE,CREATED_BY,CREATED_DATE,CREATED_SESSION,UPDATED_BY,UPDATED_DATE,UPDATED_SESSION,DELETED_BY,DELETED_DATE,DELETED_SESSION)VALUES(OPS_LOOKUPS_SEQ.NEXTVAL,'FORMULA-USER','CALC1','CALC1',NULL,NULL,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_LOOKUPS(LOOKUP_ID,LOOKUP_TYPE,LOOKUP_VALUE_KEY,LOOKUP_VALUE_NAME,LOOKUP_VALUE_DESCRIPTION,ASSOCIATED_RULE,START_DATE_ACTIVE,END_DATE_ACTIVE,CREATED_BY,CREATED_DATE,CREATED_SESSION,UPDATED_BY,UPDATED_DATE,UPDATED_SESSION,DELETED_BY,DELETED_DATE,DELETED_SESSION)VALUES(OPS_LOOKUPS_SEQ.NEXTVAL,'FORMULA-USER','CALC2','CALC2',NULL,NULL,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_LOOKUPS(LOOKUP_ID,LOOKUP_TYPE,LOOKUP_VALUE_KEY,LOOKUP_VALUE_NAME,LOOKUP_VALUE_DESCRIPTION,ASSOCIATED_RULE,START_DATE_ACTIVE,END_DATE_ACTIVE,CREATED_BY,CREATED_DATE,CREATED_SESSION,UPDATED_BY,UPDATED_DATE,UPDATED_SESSION,DELETED_BY,DELETED_DATE,DELETED_SESSION)VALUES(OPS_LOOKUPS_SEQ.NEXTVAL,'RULEBIND-TYPE','RULE','Rule',NULL,NULL,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_LOOKUPS(LOOKUP_ID,LOOKUP_TYPE,LOOKUP_VALUE_KEY,LOOKUP_VALUE_NAME,LOOKUP_VALUE_DESCRIPTION,ASSOCIATED_RULE,START_DATE_ACTIVE,END_DATE_ACTIVE,CREATED_BY,CREATED_DATE,CREATED_SESSION,UPDATED_BY,UPDATED_DATE,UPDATED_SESSION,DELETED_BY,DELETED_DATE,DELETED_SESSION)VALUES(OPS_LOOKUPS_SEQ.NEXTVAL,'TAX-TYPE','WITH','WITH',NULL,NULL,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_LOOKUPS(LOOKUP_ID,LOOKUP_TYPE,LOOKUP_VALUE_KEY,LOOKUP_VALUE_NAME,LOOKUP_VALUE_DESCRIPTION,ASSOCIATED_RULE,START_DATE_ACTIVE,END_DATE_ACTIVE,CREATED_BY,CREATED_DATE,CREATED_SESSION,UPDATED_BY,UPDATED_DATE,UPDATED_SESSION,DELETED_BY,DELETED_DATE,DELETED_SESSION)VALUES(OPS_LOOKUPS_SEQ.NEXTVAL,'TAX-TYPE','SUI','SUI',NULL,NULL,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_LOOKUPS(LOOKUP_ID,LOOKUP_TYPE,LOOKUP_VALUE_KEY,LOOKUP_VALUE_NAME,LOOKUP_VALUE_DESCRIPTION,ASSOCIATED_RULE,START_DATE_ACTIVE,END_DATE_ACTIVE,CREATED_BY,CREATED_DATE,CREATED_SESSION,UPDATED_BY,UPDATED_DATE,UPDATED_SESSION,DELETED_BY,DELETED_DATE,DELETED_SESSION)VALUES(OPS_LOOKUPS_SEQ.NEXTVAL,'RATE-TYPE','EMP','Employee',NULL,NULL,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_LOOKUPS(LOOKUP_ID,LOOKUP_TYPE,LOOKUP_VALUE_KEY,LOOKUP_VALUE_NAME,LOOKUP_VALUE_DESCRIPTION,ASSOCIATED_RULE,START_DATE_ACTIVE,END_DATE_ACTIVE,CREATED_BY,CREATED_DATE,CREATED_SESSION,UPDATED_BY,UPDATED_DATE,UPDATED_SESSION,DELETED_BY,DELETED_DATE,DELETED_SESSION)VALUES(OPS_LOOKUPS_SEQ.NEXTVAL,'RATE-TYPE','GLOBAL','Global',NULL,NULL,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_LOOKUPS(LOOKUP_ID,LOOKUP_TYPE,LOOKUP_VALUE_KEY,LOOKUP_VALUE_NAME,LOOKUP_VALUE_DESCRIPTION,ASSOCIATED_RULE,START_DATE_ACTIVE,END_DATE_ACTIVE,CREATED_BY,CREATED_DATE,CREATED_SESSION,UPDATED_BY,UPDATED_DATE,UPDATED_SESSION,DELETED_BY,DELETED_DATE,DELETED_SESSION)VALUES(OPS_LOOKUPS_SEQ.NEXTVAL,'USER-TYPE','EMPL','Employer',NULL,NULL,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_LOOKUPS(LOOKUP_ID,LOOKUP_TYPE,LOOKUP_VALUE_KEY,LOOKUP_VALUE_NAME,LOOKUP_VALUE_DESCRIPTION,ASSOCIATED_RULE,START_DATE_ACTIVE,END_DATE_ACTIVE,CREATED_BY,CREATED_DATE,CREATED_SESSION,UPDATED_BY,UPDATED_DATE,UPDATED_SESSION,DELETED_BY,DELETED_DATE,DELETED_SESSION)VALUES(OPS_LOOKUPS_SEQ.NEXTVAL,'USER-TYPE','ACC','Accountant',NULL,NULL,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_LOOKUPS(LOOKUP_ID,LOOKUP_TYPE,LOOKUP_VALUE_KEY,LOOKUP_VALUE_NAME,LOOKUP_VALUE_DESCRIPTION,ASSOCIATED_RULE,START_DATE_ACTIVE,END_DATE_ACTIVE,CREATED_BY,CREATED_DATE,CREATED_SESSION,UPDATED_BY,UPDATED_DATE,UPDATED_SESSION,DELETED_BY,DELETED_DATE,DELETED_SESSION)VALUES(OPS_LOOKUPS_SEQ.NEXTVAL,'USER-TYPE','EMP','Employee',NULL,NULL,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_LOOKUPS(LOOKUP_ID,LOOKUP_TYPE,LOOKUP_VALUE_KEY,LOOKUP_VALUE_NAME,LOOKUP_VALUE_DESCRIPTION,ASSOCIATED_RULE,START_DATE_ACTIVE,END_DATE_ACTIVE,CREATED_BY,CREATED_DATE,CREATED_SESSION,UPDATED_BY,UPDATED_DATE,UPDATED_SESSION,DELETED_BY,DELETED_DATE,DELETED_SESSION)VALUES(OPS_LOOKUPS_SEQ.NEXTVAL,'USER-TYPE','INT','Internal',NULL,NULL,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_LOOKUPS(LOOKUP_ID,LOOKUP_TYPE,LOOKUP_VALUE_KEY,LOOKUP_VALUE_NAME,LOOKUP_VALUE_DESCRIPTION,ASSOCIATED_RULE,START_DATE_ACTIVE,END_DATE_ACTIVE,CREATED_BY,CREATED_DATE,CREATED_SESSION,UPDATED_BY,UPDATED_DATE,UPDATED_SESSION,DELETED_BY,DELETED_DATE,DELETED_SESSION)VALUES(OPS_LOOKUPS_SEQ.NEXTVAL,'USER-STATUS','A','Active',NULL,NULL,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_LOOKUPS(LOOKUP_ID,LOOKUP_TYPE,LOOKUP_VALUE_KEY,LOOKUP_VALUE_NAME,LOOKUP_VALUE_DESCRIPTION,ASSOCIATED_RULE,START_DATE_ACTIVE,END_DATE_ACTIVE,CREATED_BY,CREATED_DATE,CREATED_SESSION,UPDATED_BY,UPDATED_DATE,UPDATED_SESSION,DELETED_BY,DELETED_DATE,DELETED_SESSION)VALUES(OPS_LOOKUPS_SEQ.NEXTVAL,'USER-STATUS','I','Inactive',NULL,NULL,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_LOOKUPS(LOOKUP_ID,LOOKUP_TYPE,LOOKUP_VALUE_KEY,LOOKUP_VALUE_NAME,LOOKUP_VALUE_DESCRIPTION,ASSOCIATED_RULE,START_DATE_ACTIVE,END_DATE_ACTIVE,CREATED_BY,CREATED_DATE,CREATED_SESSION,UPDATED_BY,UPDATED_DATE,UPDATED_SESSION,DELETED_BY,DELETED_DATE,DELETED_SESSION)VALUES(OPS_LOOKUPS_SEQ.NEXTVAL,'USER-STATUS','D','Deleted',NULL,NULL,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_LOOKUPS(LOOKUP_ID,LOOKUP_TYPE,LOOKUP_VALUE_KEY,LOOKUP_VALUE_NAME,LOOKUP_VALUE_DESCRIPTION,ASSOCIATED_RULE,START_DATE_ACTIVE,END_DATE_ACTIVE,CREATED_BY,CREATED_DATE,CREATED_SESSION,UPDATED_BY,UPDATED_DATE,UPDATED_SESSION,DELETED_BY,DELETED_DATE,DELETED_SESSION)VALUES(OPS_LOOKUPS_SEQ.NEXTVAL,'USER-STATUS','R','Readonly',NULL,NULL,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_LOOKUPS(LOOKUP_ID,LOOKUP_TYPE,LOOKUP_VALUE_KEY,LOOKUP_VALUE_NAME,LOOKUP_VALUE_DESCRIPTION,ASSOCIATED_RULE,START_DATE_ACTIVE,END_DATE_ACTIVE,CREATED_BY,CREATED_DATE,CREATED_SESSION,UPDATED_BY,UPDATED_DATE,UPDATED_SESSION,DELETED_BY,DELETED_DATE,DELETED_SESSION)VALUES(OPS_LOOKUPS_SEQ.NEXTVAL,'USER-STATUS','L','Locked',NULL,NULL,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_LOOKUPS(LOOKUP_ID,LOOKUP_TYPE,LOOKUP_VALUE_KEY,LOOKUP_VALUE_NAME,LOOKUP_VALUE_DESCRIPTION,ASSOCIATED_RULE,START_DATE_ACTIVE,END_DATE_ACTIVE,CREATED_BY,CREATED_DATE,CREATED_SESSION,UPDATED_BY,UPDATED_DATE,UPDATED_SESSION,DELETED_BY,DELETED_DATE,DELETED_SESSION)VALUES(OPS_LOOKUPS_SEQ.NEXTVAL,'USER-ACTION','S','Search',NULL,NULL,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_LOOKUPS(LOOKUP_ID,LOOKUP_TYPE,LOOKUP_VALUE_KEY,LOOKUP_VALUE_NAME,LOOKUP_VALUE_DESCRIPTION,ASSOCIATED_RULE,START_DATE_ACTIVE,END_DATE_ACTIVE,CREATED_BY,CREATED_DATE,CREATED_SESSION,UPDATED_BY,UPDATED_DATE,UPDATED_SESSION,DELETED_BY,DELETED_DATE,DELETED_SESSION)VALUES(OPS_LOOKUPS_SEQ.NEXTVAL,'USER-ACTION','I','Insert',NULL,NULL,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_LOOKUPS(LOOKUP_ID,LOOKUP_TYPE,LOOKUP_VALUE_KEY,LOOKUP_VALUE_NAME,LOOKUP_VALUE_DESCRIPTION,ASSOCIATED_RULE,START_DATE_ACTIVE,END_DATE_ACTIVE,CREATED_BY,CREATED_DATE,CREATED_SESSION,UPDATED_BY,UPDATED_DATE,UPDATED_SESSION,DELETED_BY,DELETED_DATE,DELETED_SESSION)VALUES(OPS_LOOKUPS_SEQ.NEXTVAL,'USER-ACTION','U','Update',NULL,NULL,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO OPS_LOOKUPS(LOOKUP_ID,LOOKUP_TYPE,LOOKUP_VALUE_KEY,LOOKUP_VALUE_NAME,LOOKUP_VALUE_DESCRIPTION,ASSOCIATED_RULE,START_DATE_ACTIVE,END_DATE_ACTIVE,CREATED_BY,CREATED_DATE,CREATED_SESSION,UPDATED_BY,UPDATED_DATE,UPDATED_SESSION,DELETED_BY,DELETED_DATE,DELETED_SESSION)VALUES(OPS_LOOKUPS_SEQ.NEXTVAL,'USER-ACTION','D','Delete',NULL,NULL,SYSDATE,NULL,0,SYSDATE,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

ALTER TABLE OPS_USER_ACTIONS MODIFY CREATED_DATE DATE;
ALTER TABLE OPS_MESSAGES ADD MESSAGE_NAME VARCHAR2(100);

ALTER TABLE OPS_USER_SESSIONS MODIFY CREATED_SESSION VARCHAR2(32);
ALTER TABLE OPS_USER_SESSIONS MODIFY UPDATED_SESSION VARCHAR2(32);
ALTER TABLE OPS_USER_SESSIONS MODIFY DELETED_SESSION VARCHAR2(32);

CREATE SEQUENCE OPS_TAX_AUTHORITY_SEQ START WITH 1000 INCREMENT BY 1 MAXVALUE 9999999999 NOCACHE NOCYCLE;
CREATE SEQUENCE OPS_RULES_SEQ START WITH 1000 INCREMENT BY 1 MAXVALUE 9999999999 NOCACHE NOCYCLE;
CREATE SEQUENCE OPS_RULE_RATES_SEQ START WITH 1000 INCREMENT BY 1 MAXVALUE 9999999999 NOCACHE NOCYCLE;
CREATE SEQUENCE OPS_RATES_SEQ START WITH 1000 INCREMENT BY 1 MAXVALUE 9999999999 NOCACHE NOCYCLE;
CREATE SEQUENCE OPS_PARAMETERS_SEQ START WITH 1000 INCREMENT BY 1 MAXVALUE 9999999999 NOCACHE NOCYCLE;
CREATE SEQUENCE OPS_MESSAGES_SEQ START WITH 1000 INCREMENT BY 1 MAXVALUE 9999999999 NOCACHE NOCYCLE;
CREATE SEQUENCE OPS_USER_SESSIONS_SEQ START WITH 1000 INCREMENT BY 1 MAXVALUE 9999999999 NOCACHE NOCYCLE;
CREATE SEQUENCE OPS_USER_ACTIONS_SEQ START WITH 1000 INCREMENT BY 1 MAXVALUE 9999999999 NOCACHE NOCYCLE;
CREATE SEQUENCE OPS_RULE_BINDS_SEQ START WITH 1000 INCREMENT BY 1 MAXVALUE 9999999999 NOCACHE NOCYCLE;

ALTER TABLE OPS_USERS DROP COLUMN USER_TYPE;

